Visual Exploratory Data Analysis of Covid-19 in Indonesia

This Data Visualization repository is solely developed for the research article mentioned here. This is only for visualization purposes and all the visualization models made from the data sources provided by Indonesia's national disaster management agency. In Indonesia, it called Badan Nasional Penanggulangan Bencana (BNPB). Here we present an approach to visualize and analyze the data of daily statistical covid 19 dataset for each province in Indonesia from its API (access in : https://bnpb-inacovid19.hub.arcgis.com/datasets/statistik-harian-per-provinsi-covid19-indonesia-rev/geoservice)

Table of Content

  1. Import Library
  2. Data Wrangling
  3. Visualization using Live Heat Maps
  4. Visualization using Bart Chart
  5. Visualization using Pie Chart
  6. Visualization using Scatter Plot
  7. Visualization using Tree Maps
  8. Simple Dashboard (Inspired by Bee Guan Teo)

Import Library

In [7]:

Data Wrangling

In [8]:
Out[8]:
<Response [200]>
In [9]:
Out[9]:
type geometry properties_Object_ID properties_Provinsi properties_Tanggal properties_Kasus_Terkonfirmasi_Akumulatif properties_Penambahan_Harian_Kasus_Terkonf properties_Kasus_Sembuh_Akumulatif properties_Penambahan_Harian_Kasus_Sembuh properties_Kasus_Meninggal_Akumulatif properties_Penambahan_Harian_Kasus_Meningg properties_Kasus_Aktif_Akumulatif properties_CFR_Harian properties_RI_Harian properties_FID properties_ObjectId
0 Feature None 1.0 Aceh 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #DIV/0! #DIV/0! 1.0 3572
1 Feature None 2.0 Bali 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #DIV/0! #DIV/0! 2.0 3573
2 Feature None 3.0 Banten 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #DIV/0! #DIV/0! 3.0 3574
3 Feature None 4.0 Kepulauan Bangka Belitung 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #DIV/0! #DIV/0! 4.0 3575
4 Feature None 5.0 Bengkulu 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 #DIV/0! #DIV/0! 5.0 3576
In [10]:
Out[10]:
type geometry properties_Object_ID properties_Provinsi properties_Tanggal properties_Kasus_Terkonfirmasi_Akumulatif properties_Penambahan_Harian_Kasus_Terkonf properties_Kasus_Sembuh_Akumulatif properties_Penambahan_Harian_Kasus_Sembuh properties_Kasus_Meninggal_Akumulatif properties_Penambahan_Harian_Kasus_Meningg properties_Kasus_Aktif_Akumulatif properties_CFR_Harian properties_RI_Harian properties_FID properties_ObjectId
8278 Feature None 8279.0 Papua Barat 2020/11/02 00:00:00+00 4189.0 326.0 3655.0 423.0 66.0 19.0 468.0 1.5755550250656483 87.25232752446884 8279.0 12239
8279 Feature None 8280.0 Papua 2020/11/02 00:00:00+00 9037.0 4848.0 4637.0 982.0 129.0 63.0 4271.0 1.4274648666592897 51.311275865884696 8280.0 12240
8280 Feature None 8281.0 Sulawesi Barat 2020/11/02 00:00:00+00 1036.0 -8001.0 841.0 -3796.0 14.0 -115.0 181.0 1.3513513513513513 81.17760617760618 8281.0 12241
8281 Feature None 8282.0 Nusa Tenggara Timur 2020/11/02 00:00:00+00 694.0 -342.0 500.0 -340.0 7.0 -7.0 187.0 1.0086455331412103 72.04610951008645 8282.0 12242
8282 Feature None 8283.0 Gorontalo 2020/11/02 00:00:00+00 3021.0 2331.0 2859.0 2360.0 85.0 78.0 77.0 2.8136378682555447 94.63753723932473 8283.0 12243
In [11]:
Out[11]:
properties_Provinsi properties_Tanggal properties_Kasus_Terkonfirmasi_Akumulatif properties_Penambahan_Harian_Kasus_Terkonf properties_Kasus_Sembuh_Akumulatif properties_Penambahan_Harian_Kasus_Sembuh properties_Kasus_Meninggal_Akumulatif properties_Penambahan_Harian_Kasus_Meningg properties_Kasus_Aktif_Akumulatif
0 Aceh 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 Bali 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
2 Banten 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
3 Kepulauan Bangka Belitung 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
4 Bengkulu 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
... ... ... ... ... ... ... ... ... ...
8278 Papua Barat 2020/11/02 00:00:00+00 4189.0 326.0 3655.0 423.0 66.0 19.0 468.0
8279 Papua 2020/11/02 00:00:00+00 9037.0 4848.0 4637.0 982.0 129.0 63.0 4271.0
8280 Sulawesi Barat 2020/11/02 00:00:00+00 1036.0 -8001.0 841.0 -3796.0 14.0 -115.0 181.0
8281 Nusa Tenggara Timur 2020/11/02 00:00:00+00 694.0 -342.0 500.0 -340.0 7.0 -7.0 187.0
8282 Gorontalo 2020/11/02 00:00:00+00 3021.0 2331.0 2859.0 2360.0 85.0 78.0 77.0

8283 rows × 9 columns

In [12]:
In [13]:
Out[13]:
state date Total_Terkonfirmasi Terkonfirmasi_Harian Total_Sembuh Sembuh_Harian Total_MeninggalDunia MeninggalDunia_Harian Total_Aktif
0 Aceh 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 Bali 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
2 Banten 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
3 Kepulauan Bangka Belitung 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
4 Bengkulu 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
... ... ... ... ... ... ... ... ... ...
8278 Papua Barat 2020/11/02 00:00:00+00 4189.0 326.0 3655.0 423.0 66.0 19.0 468.0
8279 Papua 2020/11/02 00:00:00+00 9037.0 4848.0 4637.0 982.0 129.0 63.0 4271.0
8280 Sulawesi Barat 2020/11/02 00:00:00+00 1036.0 -8001.0 841.0 -3796.0 14.0 -115.0 181.0
8281 Nusa Tenggara Timur 2020/11/02 00:00:00+00 694.0 -342.0 500.0 -340.0 7.0 -7.0 187.0
8282 Gorontalo 2020/11/02 00:00:00+00 3021.0 2331.0 2859.0 2360.0 85.0 78.0 77.0

8283 rows × 9 columns

In [14]:
Out[14]:
state                    35
date                      0
Total_Terkonfirmasi      35
Terkonfirmasi_Harian     35
Total_Sembuh             35
Sembuh_Harian            35
Total_MeninggalDunia     35
MeninggalDunia_Harian    35
Total_Aktif              35
dtype: int64
In [15]:
In [16]:
Out[16]:
state date Total_Terkonfirmasi Terkonfirmasi_Harian Total_Sembuh Sembuh_Harian Total_MeninggalDunia MeninggalDunia_Harian Total_Aktif
0 Aceh 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
1 Bali 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
2 Banten 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
3 Kepulauan Bangka Belitung 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
4 Bengkulu 2020/03/02 00:00:00+00 0.0 0.0 0.0 0.0 0.0 0.0 0.0
... ... ... ... ... ... ... ... ... ...
8278 Papua Barat 2020/11/02 00:00:00+00 4189.0 326.0 3655.0 423.0 66.0 19.0 468.0
8279 Papua 2020/11/02 00:00:00+00 9037.0 4848.0 4637.0 982.0 129.0 63.0 4271.0
8280 Sulawesi Barat 2020/11/02 00:00:00+00 1036.0 -8001.0 841.0 -3796.0 14.0 -115.0 181.0
8281 Nusa Tenggara Timur 2020/11/02 00:00:00+00 694.0 -342.0 500.0 -340.0 7.0 -7.0 187.0
8282 Gorontalo 2020/11/02 00:00:00+00 3021.0 2331.0 2859.0 2360.0 85.0 78.0 77.0

8127 rows × 9 columns

Visualization Using Live Heat Maps

In [17]:
In [18]:
In [19]:
In [20]:
In [ ]:

All data sort by state (Part of Data Wrangling)

In [21]:
 

/srv/conda/envs/notebook/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning:

Indexing with multiple keys (implicitly converted to a tuple of keys) will be deprecated, use a list instead.
Out[21]:
state Total_Terkonfirmasi Total_MeninggalDunia Total_Sembuh Total_Aktif
0 Aceh 326043.000000 11871.000000 177275.000000 136900.000000
1 Bali 781295.000000 19241.000000 646115.000000 115918.000000
2 Banten 543725.000000 21217.000000 361251.000000 160633.000000
3 Bengkulu 60287.000000 3554.000000 39109.000000 17638.000000
4 DKI Jakarta 6473081.000000 194066.000000 4842473.000000 1434413.000000
5 Daerah Istimewa Yogyakarta 220433.000000 6057.000000 162641.000000 51837.000000
6 Gorontalo 231268.000000 6634.000000 192835.000000 31633.000000
7 Jambi 56879.000000 974.000000 27170.000000 28696.000000
8 Jawa Barat 1971127.000000 50630.000000 1153492.000000 765380.000000
9 Jawa Tengah 2073401.000000 124116.000000 1389206.000000 559340.000000
10 Jawa Timur 4295714.000000 315008.000000 3169729.000000 802858.000000
11 Kalimantan Barat 104027.000000 1102.000000 82927.000000 19860.000000
12 Kalimantan Selatan 1041105.000000 46558.000000 730469.000000 262898.000000
13 Kalimantan Tengah 346401.000000 14438.000000 253844.000000 77953.000000
14 Kalimantan Timur 678897.000000 24349.000000 463813.000000 190977.000000
15 Kalimantan Utara 63373.000000 501.000000 49744.000000 13214.000000
16 Kepulauan Bangka Belitung 26690.000000 343.000000 22188.000000 4150.000000
17 Kepulauan Riau 182769.000000 5952.000000 124181.000000 52497.000000
18 Lampung 86010.000000 3757.000000 57011.000000 25118.000000
19 Maluku 267487.000000 4257.000000 171796.000000 90997.000000
20 Maluku Utara 220553.000000 7867.000000 147279.000000 65310.000000
21 Nusa Tenggara Barat 362233.000000 19379.000000 261175.000000 81161.000000
22 Nusa Tenggara Timur 40031.000000 464.000000 26018.000000 13406.000000
23 Papua 616708.000000 7798.000000 341214.000000 266721.000000
24 Papua Barat 182948.000000 2776.000000 122054.000000 58038.000000
25 Riau 547651.000000 12183.000000 336591.000000 198885.000000
26 Sulawesi Barat 63441.000000 1002.000000 42945.000000 19459.000000
27 Sulawesi Selatan 1596013.000000 47752.000000 1142945.000000 404132.000000
28 Sulawesi Tengah 50885.000000 1883.000000 36264.000000 12814.000000
29 Sulawesi Tenggara 255197.000000 4722.000000 170973.000000 79578.000000
30 Sulawesi Utara 446208.000000 19940.000000 302061.000000 123557.000000
31 Sumatera Barat 554293.000000 12511.000000 323849.000000 218044.000000
32 Sumatera Selatan 628990.000000 33086.000000 414082.000000 180472.000000
33 Sumatera Utara 901519.000000 40479.000000 559077.000000 301695.000000

All Data sort by date (Part of Data Wrangling)

In [22]:
 

/srv/conda/envs/notebook/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning:

Indexing with multiple keys (implicitly converted to a tuple of keys) will be deprecated, use a list instead.
Out[22]:
date Total_Terkonfirmasi Total_MeninggalDunia Total_Sembuh Total_Aktif
0 1970/01/01 00:00:00+00 0.000000 0.000000 0.000000 0.000000
1 2020/03/02 00:00:00+00 2.000000 0.000000 0.000000 2.000000
2 2020/03/03 00:00:00+00 2.000000 0.000000 0.000000 2.000000
3 2020/03/04 00:00:00+00 2.000000 0.000000 0.000000 2.000000
4 2020/03/05 00:00:00+00 2.000000 0.000000 0.000000 2.000000
5 2020/03/06 00:00:00+00 4.000000 0.000000 0.000000 4.000000
6 2020/03/07 00:00:00+00 4.000000 0.000000 0.000000 4.000000
7 2020/03/08 00:00:00+00 6.000000 0.000000 0.000000 6.000000
8 2020/03/09 00:00:00+00 19.000000 0.000000 0.000000 19.000000
9 2020/03/10 00:00:00+00 27.000000 0.000000 0.000000 27.000000
10 2020/03/11 00:00:00+00 34.000000 1.000000 2.000000 31.000000
11 2020/03/12 00:00:00+00 34.000000 1.000000 2.000000 31.000000
12 2020/03/13 00:00:00+00 69.000000 4.000000 3.000000 62.000000
13 2020/03/14 00:00:00+00 92.000000 5.000000 8.000000 79.000000
14 2020/03/15 00:00:00+00 113.000000 5.000000 8.000000 100.000000
15 2020/03/16 00:00:00+00 130.000000 5.000000 8.000000 117.000000
16 2020/03/17 00:00:00+00 172.000000 5.000000 9.000000 158.000000
17 2020/03/18 00:00:00+00 227.000000 19.000000 11.000000 197.000000
18 2020/03/19 00:00:00+00 309.000000 19.000000 15.000000 275.000000
19 2020/03/20 00:00:00+00 356.000000 32.000000 17.000000 307.000000
20 2020/03/21 00:00:00+00 440.000000 38.000000 20.000000 382.000000
21 2020/03/22 00:00:00+00 508.000000 48.000000 29.000000 431.000000
22 2020/03/23 00:00:00+00 571.000000 49.000000 30.000000 492.000000
23 2020/03/24 00:00:00+00 681.000000 55.000000 30.000000 596.000000
24 2020/03/25 00:00:00+00 778.000000 58.000000 31.000000 689.000000
25 2020/03/26 00:00:00+00 873.000000 78.000000 35.000000 760.000000
26 2020/03/27 00:00:00+00 1018.000000 87.000000 46.000000 885.000000
27 2020/03/28 00:00:00+00 1125.000000 102.000000 59.000000 964.000000
28 2020/03/29 00:00:00+00 1252.000000 114.000000 64.000000 1074.000000
29 2020/03/30 00:00:00+00 1377.000000 122.000000 75.000000 1180.000000
30 2020/03/31 00:00:00+00 1500.000000 136.000000 81.000000 1283.000000
31 2020/04/01 00:00:00+00 1649.000000 157.000000 103.000000 1389.000000
32 2020/04/02 00:00:00+00 1762.000000 170.000000 112.000000 1480.000000
33 2020/04/03 00:00:00+00 1955.000000 181.000000 134.000000 1640.000000
34 2020/04/04 00:00:00+00 2055.000000 191.000000 150.000000 1714.000000
35 2020/04/05 00:00:00+00 2231.000000 198.000000 164.000000 1869.000000
36 2020/04/06 00:00:00+00 2457.000000 209.000000 192.000000 2056.000000
37 2020/04/07 00:00:00+00 2704.000000 221.000000 204.000000 2279.000000
38 2020/04/08 00:00:00+00 2922.000000 240.000000 222.000000 2460.000000
39 2020/04/09 00:00:00+00 3259.000000 280.000000 252.000000 2727.000000
40 2020/04/10 00:00:00+00 3477.000000 306.000000 282.000000 2889.000000
41 2020/04/11 00:00:00+00 3807.000000 327.000000 286.000000 3194.000000
42 2020/04/12 00:00:00+00 4206.000000 373.000000 359.000000 3474.000000
43 2020/04/13 00:00:00+00 4531.000000 399.000000 380.000000 3752.000000
44 2020/04/14 00:00:00+00 4812.000000 459.000000 426.000000 3927.000000
45 2020/04/15 00:00:00+00 5109.000000 469.000000 446.000000 4194.000000
46 2020/04/16 00:00:00+00 5489.000000 496.000000 548.000000 4445.000000
47 2020/04/17 00:00:00+00 5897.000000 520.000000 607.000000 4770.000000
48 2020/04/18 00:00:00+00 6222.000000 535.000000 631.000000 5056.000000
49 2020/04/19 00:00:00+00 6549.000000 582.000000 686.000000 5281.000000
50 2020/04/20 00:00:00+00 6733.000000 590.000000 747.000000 5396.000000
51 2020/04/21 00:00:00+00 7108.000000 616.000000 842.000000 5650.000000
52 2020/04/22 00:00:00+00 7391.000000 636.000000 913.000000 5842.000000
53 2020/04/23 00:00:00+00 7748.000000 647.000000 960.000000 6141.000000
54 2020/04/24 00:00:00+00 8185.000000 689.000000 1002.000000 6494.000000
55 2020/04/25 00:00:00+00 8581.000000 720.000000 1042.000000 6819.000000
56 2020/04/26 00:00:00+00 8856.000000 743.000000 1107.000000 7006.000000
57 2020/04/27 00:00:00+00 9070.000000 765.000000 1151.000000 7154.000000
58 2020/04/28 00:00:00+00 9484.000000 773.000000 1254.000000 7457.000000
59 2020/04/29 00:00:00+00 9744.000000 784.000000 1391.000000 7569.000000
60 2020/04/30 00:00:00+00 10092.000000 792.000000 1522.000000 7778.000000
61 2020/05/01 00:00:00+00 10525.000000 800.000000 1591.000000 8134.000000
62 2020/05/02 00:00:00+00 10819.000000 831.000000 1665.000000 8323.000000
63 2020/05/03 00:00:00+00 11168.000000 845.000000 1876.000000 8447.000000
64 2020/05/04 00:00:00+00 11565.000000 864.000000 1954.000000 8747.000000
65 2020/05/05 00:00:00+00 12049.000000 872.000000 2197.000000 8980.000000
66 2020/05/06 00:00:00+00 12416.000000 895.000000 2317.000000 9204.000000
67 2020/05/07 00:00:00+00 12754.000000 930.000000 2381.000000 9443.000000
68 2020/05/08 00:00:00+00 13091.000000 943.000000 2494.000000 9654.000000
69 2020/05/09 00:00:00+00 13624.000000 959.000000 2604.000000 10061.000000
70 2020/05/10 00:00:00+00 14011.000000 973.000000 2698.000000 10340.000000
71 2020/05/11 00:00:00+00 14244.000000 991.000000 2880.000000 10373.000000
72 2020/05/12 00:00:00+00 14728.000000 1007.000000 3063.000000 10658.000000
73 2020/05/13 00:00:00+00 15417.000000 1028.000000 3287.000000 11102.000000
74 2020/05/14 00:00:00+00 15985.000000 1043.000000 3518.000000 11424.000000
75 2020/05/15 00:00:00+00 16475.000000 1076.000000 3803.000000 11596.000000
76 2020/05/16 00:00:00+00 17004.000000 1089.000000 3911.000000 12004.000000
77 2020/05/17 00:00:00+00 17493.000000 1148.000000 4129.000000 12216.000000
78 2020/05/18 00:00:00+00 17989.000000 1191.000000 4324.000000 12474.000000
79 2020/05/19 00:00:00+00 18475.000000 1221.000000 4467.000000 12787.000000
80 2020/05/20 00:00:00+00 19168.000000 1242.000000 4575.000000 13351.000000
81 2020/05/21 00:00:00+00 20141.000000 1278.000000 4838.000000 14025.000000
82 2020/05/22 00:00:00+00 20775.000000 1326.000000 5057.000000 11596.000000
83 2020/05/23 00:00:00+00 21724.000000 1351.000000 5249.000000 12004.000000
84 2020/05/24 00:00:00+00 22250.000000 1372.000000 5402.000000 12216.000000
85 2020/05/25 00:00:00+00 22729.000000 1391.000000 5642.000000 12474.000000
86 2020/05/26 00:00:00+00 23144.000000 1418.000000 5877.000000 12787.000000
87 2020/05/27 00:00:00+00 23930.000000 1473.000000 6057.000000 16400.000000
88 2020/05/28 00:00:00+00 24517.000000 1496.000000 6240.000000 12787.000000
89 2020/05/29 00:00:00+00 25195.000000 1520.000000 6492.000000 16400.000000
90 2020/05/30 00:00:00+00 25752.000000 1573.000000 7015.000000 17164.000000
91 2020/05/31 00:00:00+00 26452.000000 1613.000000 7308.000000 17531.000000
92 2020/06/01 00:00:00+00 26919.000000 1641.000000 7637.000000 17641.000000
93 2020/06/02 00:00:00+00 27528.000000 1663.000000 7935.000000 17930.000000
94 2020/06/03 00:00:00+00 28212.000000 1698.000000 8406.000000 18108.000000
95 2020/06/04 00:00:00+00 28797.000000 1721.000000 8892.000000 18184.000000
96 2020/06/05 00:00:00+00 29500.000000 1770.000000 9443.000000 18287.000000
97 2020/06/06 00:00:00+00 30493.000000 1801.000000 9907.000000 18785.000000
98 2020/06/07 00:00:00+00 31165.000000 1851.000000 10498.000000 18816.000000
99 2020/06/08 00:00:00+00 32012.000000 1883.000000 10904.000000 19225.000000
100 2020/06/09 00:00:00+00 33055.000000 1923.000000 11414.000000 19718.000000
101 2020/06/10 00:00:00+00 34295.000000 1959.000000 12129.000000 20207.000000
102 2020/06/11 00:00:00+00 35295.000000 2000.000000 12636.000000 20659.000000
103 2020/06/12 00:00:00+00 36406.000000 2048.000000 13213.000000 21145.000000
104 2020/06/13 00:00:00+00 37420.000000 2091.000000 13776.000000 21553.000000
105 2020/06/14 00:00:00+00 38277.000000 2134.000000 14531.000000 21612.000000
106 2020/06/15 00:00:00+00 39294.000000 2198.000000 15123.000000 21973.000000
107 2020/06/16 00:00:00+00 40397.000000 2231.000000 15703.000000 22463.000000
108 2020/06/17 00:00:00+00 41431.000000 2276.000000 16243.000000 22912.000000
109 2020/06/18 00:00:00+00 42762.000000 2339.000000 16798.000000 23625.000000
110 2020/06/19 00:00:00+00 43803.000000 2373.000000 17349.000000 24081.000000
111 2020/06/20 00:00:00+00 45029.000000 2429.000000 17883.000000 24717.000000
112 2020/06/21 00:00:00+00 45891.000000 2465.000000 18404.000000 25022.000000
113 2020/06/22 00:00:00+00 46845.000000 2500.000000 18735.000000 25610.000000
114 2020/06/23 00:00:00+00 47896.000000 2535.000000 19241.000000 26120.000000
115 2020/06/24 00:00:00+00 49009.000000 2573.000000 19638.000000 26798.000000
116 2020/06/25 00:00:00+00 50187.000000 2620.000000 20449.000000 27118.000000
117 2020/06/26 00:00:00+00 51427.000000 2683.000000 21333.000000 27411.000000
118 2020/06/27 00:00:00+00 52811.000000 2720.000000 21909.000000 28182.000000
119 2020/06/28 00:00:00+00 54006.000000 2754.000000 22936.000000 28316.000000
120 2020/06/29 00:00:00+00 55088.000000 2805.000000 23800.000000 28483.000000
121 2020/06/30 00:00:00+00 56381.000000 2876.000000 24806.000000 28699.000000
122 2020/07/01 00:00:00+00 57766.000000 2934.000000 25595.000000 29237.000000
123 2020/07/02 00:00:00+00 59390.000000 2987.000000 26667.000000 29736.000000
124 2020/07/03 00:00:00+00 60691.000000 3036.000000 27568.000000 30087.000000
125 2020/07/04 00:00:00+00 62140.000000 3089.000000 28219.000000 30832.000000
126 2020/07/05 00:00:00+00 63747.000000 3171.000000 29105.000000 31471.000000
127 2020/07/06 00:00:00+00 64956.000000 3241.000000 29919.000000 31796.000000
128 2020/07/07 00:00:00+00 66224.000000 3309.000000 30785.000000 32130.000000
129 2020/07/08 00:00:00+00 68077.000000 3359.000000 31585.000000 33133.000000
130 2020/07/09 00:00:00+00 70734.000000 3417.000000 32651.000000 34666.000000
131 2020/07/10 00:00:00+00 72313.000000 3469.000000 33529.000000 35315.000000
132 2020/07/11 00:00:00+00 73984.000000 3535.000000 34719.000000 35730.000000
133 2020/07/12 00:00:00+00 75665.000000 3606.000000 35638.000000 36421.000000
134 2020/07/13 00:00:00+00 76947.000000 3656.000000 36687.000000 36604.000000
135 2020/07/14 00:00:00+00 78538.000000 3710.000000 37636.000000 37192.000000
136 2020/07/15 00:00:00+00 80060.000000 3797.000000 39050.000000 37213.000000
137 2020/07/16 00:00:00+00 81644.000000 3873.000000 40345.000000 37426.000000
138 2020/07/17 00:00:00+00 83106.000000 3957.000000 41834.000000 37315.000000
139 2020/07/18 00:00:00+00 84854.000000 4016.000000 43243.000000 37595.000000
140 2020/07/19 00:00:00+00 88194.000000 4239.000000 46952.000000 37003.000000
141 2020/07/20 00:00:00+00 88194.000000 4239.000000 46952.000000 37003.000000
142 2020/07/21 00:00:00+00 89851.000000 4320.000000 48441.000000 37090.000000
143 2020/07/22 00:00:00+00 91732.000000 4459.000000 50234.000000 37039.000000
144 2020/07/23 00:00:00+00 93637.000000 4576.000000 52137.000000 36924.000000
145 2020/07/24 00:00:00+00 95395.000000 4665.000000 53918.000000 36812.000000
146 2020/07/25 00:00:00+00 97262.000000 4714.000000 55324.000000 37224.000000
147 2020/07/27 00:00:00+00 98752.000000 4781.000000 56624.000000 37347.000000
148 2020/07/28 00:00:00+00 100274.000000 4838.000000 58142.000000 37294.000000
149 2020/07/30 00:00:00+00 106324.000000 5058.000000 64292.000000 36974.000000
150 2020/07/31 00:00:00+00 108364.000000 5131.000000 65907.000000 37326.000000
151 2020/08/02 00:00:00+00 111443.000000 5236.000000 68975.000000 37232.000000
152 2020/08/03 00:00:00+00 113119.000000 5302.000000 70237.000000 37580.000000
153 2020/08/04 00:00:00+00 115041.000000 5388.000000 72048.000000 37605.000000
154 2020/08/05 00:00:00+00 116855.000000 5452.000000 73880.000000 37523.000000
155 2020/08/06 00:00:00+00 118737.000000 5521.000000 75636.000000 37580.000000
156 2020/08/07 00:00:00+00 121207.000000 5593.000000 77545.000000 38069.000000
157 2020/08/09 00:00:00+00 123494.000000 5658.000000 79291.000000 38545.000000
158 2020/08/10 00:00:00+00 127071.000000 5765.000000 82220.000000 39086.000000
159 2020/08/11 00:00:00+00 128764.000000 5824.000000 83694.000000 39246.000000
160 2020/08/12 00:00:00+00 130706.000000 5903.000000 85776.000000 39027.000000
161 2020/08/14 00:00:00+00 135109.000000 6021.000000 89596.000000 39492.000000
162 2020/08/15 00:00:00+00 135109.000000 6021.000000 89596.000000 39492.000000
163 2020/08/16 00:00:00+00 139528.000000 6150.000000 93080.000000 40298.000000
164 2020/08/17 00:00:00+00 141347.000000 6207.000000 94435.000000 40705.000000
165 2020/08/18 00:00:00+00 143018.000000 6277.000000 96281.000000 40460.000000
166 2020/08/19 00:00:00+00 144917.000000 6346.000000 98629.000000 39942.000000
167 2020/08/20 00:00:00+00 147182.000000 6418.000000 100646.000000 40118.000000
168 2020/08/21 00:00:00+00 149377.000000 6500.000000 102963.000000 39914.000000
169 2020/08/22 00:00:00+00 151463.000000 6594.000000 105170.000000 39699.000000
170 2020/08/23 00:00:00+00 153498.000000 6680.000000 107472.000000 39346.000000
171 2020/08/24 00:00:00+00 155375.000000 6759.000000 111030.000000 37586.000000
172 2020/08/25 00:00:00+00 157819.000000 6858.000000 112832.000000 38129.000000
173 2020/08/26 00:00:00+00 160121.000000 6944.000000 115370.000000 37807.000000
174 2020/08/29 00:00:00+00 169151.000000 7261.000000 122758.000000 39132.000000
175 2020/08/30 00:00:00+00 172005.000000 7343.000000 124141.000000 40521.000000
176 2020/08/31 00:00:00+00 174748.000000 7417.000000 125909.000000 41422.000000
177 2020/09/01 00:00:00+00 177523.000000 7505.000000 128007.000000 42011.000000
178 2020/09/02 00:00:00+00 180598.000000 7616.000000 129920.000000 43062.000000
179 2020/09/03 00:00:00+00 184219.000000 7750.000000 132002.000000 44467.000000
180 2020/09/04 00:00:00+00 187486.000000 7832.000000 134126.000000 45528.000000
181 2020/09/05 00:00:00+00 190614.000000 7940.000000 136343.000000 46331.000000
182 2020/09/06 00:00:00+00 190614.000000 7940.000000 136343.000000 46331.000000
183 2020/09/07 00:00:00+00 196937.000000 8130.000000 140594.000000 48213.000000
184 2020/09/08 00:00:00+00 199976.000000 8230.000000 142896.000000 48850.000000
185 2020/09/10 00:00:00+00 203281.000000 8336.000000 145138.000000 49807.000000
186 2020/09/11 00:00:00+00 203281.000000 8336.000000 145138.000000 49807.000000
187 2020/09/12 00:00:00+00 214662.000000 8649.000000 152394.000000 53619.000000
188 2020/09/13 00:00:00+00 218290.000000 8722.000000 154944.000000 54624.000000
189 2020/09/14 00:00:00+00 221431.000000 8840.000000 158339.000000 54252.000000
190 2020/09/15 00:00:00+00 224937.000000 8964.000000 160994.000000 54979.000000
191 2020/09/16 00:00:00+00 224937.000000 8964.000000 160994.000000 54979.000000
192 2020/09/17 00:00:00+00 232514.000000 9221.000000 166613.000000 56680.000000
193 2020/09/18 00:00:00+00 236404.000000 9334.000000 170698.000000 56372.000000
194 2020/09/19 00:00:00+00 240568.000000 9446.000000 174261.000000 56861.000000
195 2020/09/20 00:00:00+00 244556.000000 9551.000000 177236.000000 57769.000000
196 2020/09/21 00:00:00+00 248731.000000 9675.000000 180702.000000 58354.000000
197 2020/09/22 00:00:00+00 252794.000000 9835.000000 184202.000000 58757.000000
198 2020/09/23 00:00:00+00 257245.000000 9975.000000 187862.000000 59408.000000
199 2020/09/24 00:00:00+00 261878.000000 10103.000000 191752.000000 60023.000000
200 2020/09/25 00:00:00+00 266700.000000 10216.000000 196092.000000 60392.000000
201 2020/09/26 00:00:00+00 271193.000000 10306.000000 199298.000000 61589.000000
202 2020/09/27 00:00:00+00 275067.000000 10384.000000 202896.000000 61787.000000
203 2020/09/28 00:00:00+00 278576.000000 10471.000000 206743.000000 61362.000000
204 2020/09/29 00:00:00+00 282568.000000 10599.000000 210308.000000 61661.000000
205 2020/09/30 00:00:00+00 286838.000000 10738.000000 214817.000000 61283.000000
206 2020/10/01 00:00:00+00 286838.000000 10738.000000 214817.000000 61283.000000
207 2020/10/02 00:00:00+00 295303.000000 10969.000000 221201.000000 63133.000000
208 2020/10/03 00:00:00+00 299291.000000 11052.000000 224909.000000 63330.000000
209 2020/10/04 00:00:00+00 303278.000000 11147.000000 228304.000000 63827.000000
210 2020/10/05 00:00:00+00 306888.000000 11249.000000 232438.000000 63201.000000
211 2020/10/06 00:00:00+00 310939.000000 11370.000000 236280.000000 63289.000000
212 2020/10/07 00:00:00+00 315467.000000 11468.000000 240133.000000 63866.000000
213 2020/10/08 00:00:00+00 320315.000000 11576.000000 243902.000000 64837.000000
214 2020/10/09 00:00:00+00 324395.000000 11673.000000 247507.000000 65215.000000
215 2020/10/10 00:00:00+00 324395.000000 11673.000000 247507.000000 65215.000000
216 2020/10/11 00:00:00+00 333166.000000 11840.000000 254839.000000 66487.000000
217 2020/10/12 00:00:00+00 336433.000000 11931.000000 258329.000000 66173.000000
218 2020/10/13 00:00:00+00 340338.000000 12023.000000 263093.000000 65222.000000
219 2020/10/14 00:00:00+00 344460.000000 12152.000000 267622.000000 64686.000000
220 2020/10/15 00:00:00+00 348867.000000 12264.000000 273422.000000 63181.000000
221 2020/10/16 00:00:00+00 348867.000000 12264.000000 273422.000000 63181.000000
222 2020/10/17 00:00:00+00 357454.000000 12427.000000 281335.000000 63692.000000
223 2020/10/18 00:00:00+00 361543.000000 12506.000000 285061.000000 63976.000000
224 2020/10/19 00:00:00+00 364915.000000 12612.000000 288965.000000 63338.000000
225 2020/10/20 00:00:00+00 368510.000000 12729.000000 293370.000000 62411.000000
226 2020/10/21 00:00:00+00 372762.000000 12852.000000 297221.000000 62689.000000
227 2020/10/22 00:00:00+00 377188.000000 12954.000000 300711.000000 63523.000000
228 2020/10/23 00:00:00+00 381557.000000 13072.000000 304802.000000 63683.000000
229 2020/10/24 00:00:00+00 385622.000000 13200.000000 308919.000000 63503.000000
230 2020/10/25 00:00:00+00 389350.000000 13294.000000 313462.000000 62594.000000
231 2020/10/26 00:00:00+00 392571.000000 13406.000000 317363.000000 61802.000000
232 2020/10/27 00:00:00+00 396079.000000 13507.000000 321926.000000 60646.000000
233 2020/10/28 00:00:00+00 400101.000000 13607.000000 325456.000000 61038.000000
234 2020/10/29 00:00:00+00 403661.000000 13696.000000 329439.000000 60526.000000
235 2020/10/30 00:00:00+00 406555.000000 13777.000000 333956.000000 58822.000000
236 2020/10/31 00:00:00+00 409696.000000 13864.000000 337450.000000 58382.000000
237 2020/11/01 00:00:00+00 412388.000000 13938.000000 341589.000000 56861.000000
238 2020/11/02 00:00:00+00 415001.000000 14039.000000 345206.000000 55756.000000
In [23]:
Out[23]:
'2020/11/02 00:00:00+00'

Total Confirmed Case in Latest Date (Part of Data Wrangling)

In [24]:
Out[24]:
index state date Total_Terkonfirmasi Terkonfirmasi_Harian Total_Sembuh Sembuh_Harian Total_MeninggalDunia MeninggalDunia_Harian Total_Aktif
0 8249 Aceh 2020/11/02 00:00:00+00 7457.0 4440.0 5173.0 2321.0 270.0 185.0 2014.0
1 8250 Bali 2020/11/02 00:00:00+00 11846.0 4420.0 10766.0 5729.0 391.0 121.0 689.0
2 8251 Banten 2020/11/02 00:00:00+00 9654.0 -2167.0 7578.0 -3103.0 275.0 -114.0 1801.0
3 8252 Kepulauan Bangka Belitung 2020/11/02 00:00:00+00 191.0 -9389.0 173.0 -7355.0 2.0 -269.0 16.0
4 8253 Bengkulu 2020/11/02 00:00:00+00 1087.0 896.0 833.0 660.0 52.0 50.0 202.0
5 8254 Daerah Istimewa Yogyakarta 2020/11/02 00:00:00+00 3883.0 2801.0 3209.0 2406.0 94.0 45.0 580.0
6 8255 DKI Jakarta 2020/11/02 00:00:00+00 107229.0 103378.0 95783.0 92623.0 2288.0 2195.0 9158.0
7 8256 Jambi 2020/11/02 00:00:00+00 1230.0 -104975.0 619.0 -94107.0 23.0 -2247.0 588.0
8 8257 Jawa Barat 2020/11/02 00:00:00+00 36924.0 35694.0 26671.0 26052.0 732.0 709.0 9521.0
9 8258 Jawa Tengah 2020/11/02 00:00:00+00 34618.0 -1965.0 28788.0 2506.0 1766.0 1045.0 4064.0
10 8259 Jawa Timur 2020/11/02 00:00:00+00 53002.0 18632.0 47001.0 18575.0 3799.0 2043.0 2202.0
11 8260 Kalimantan Barat 2020/11/02 00:00:00+00 1677.0 -51041.0 1338.0 -45363.0 21.0 -3755.0 318.0
12 8261 Kalimantan Timur 2020/11/02 00:00:00+00 14345.0 12668.0 11500.0 10162.0 489.0 468.0 2356.0
13 8262 Kalimantan Tengah 2020/11/02 00:00:00+00 4381.0 -9878.0 3906.0 -7344.0 153.0 -334.0 322.0
14 8263 Kalimantan Selatan 2020/11/02 00:00:00+00 11893.0 7549.0 10873.0 6993.0 487.0 336.0 533.0
15 8264 Kalimantan Utara 2020/11/02 00:00:00+00 829.0 -11052.0 722.0 -10126.0 8.0 -479.0 99.0
16 8265 Kepulauan Riau 2020/11/02 00:00:00+00 4047.0 3221.0 2775.0 2059.0 94.0 87.0 1178.0
17 8266 Nusa Tenggara Barat 2020/11/02 00:00:00+00 3998.0 -27.0 3272.0 604.0 222.0 128.0 504.0
18 8267 Sumatera Selatan 2020/11/02 00:00:00+00 7921.0 3925.0 6394.0 3131.0 428.0 207.0 1099.0
19 8268 Sumatera Barat 2020/11/02 00:00:00+00 14940.0 7037.0 10764.0 4379.0 270.0 -153.0 3906.0
20 8269 Sulawesi Utara 2020/11/02 00:00:00+00 5452.0 -9310.0 4585.0 -5929.0 205.0 -60.0 662.0
21 8270 Sumatera Utara 2020/11/02 00:00:00+00 13277.0 7849.0 10846.0 6280.0 542.0 338.0 1889.0
22 8271 Sulawesi Tenggara 2020/11/02 00:00:00+00 5073.0 -8125.0 4034.0 -6744.0 83.0 -453.0 956.0
23 8272 Sulawesi Selatan 2020/11/02 00:00:00+00 18372.0 13302.0 16617.0 12670.0 468.0 386.0 1287.0
24 8273 Sulawesi Tengah 2020/11/02 00:00:00+00 878.0 -17492.0 672.0 -15879.0 36.0 -431.0 170.0
25 8274 Lampung 2020/11/02 00:00:00+00 1884.0 1008.0 1120.0 468.0 78.0 44.0 686.0
26 8275 Riau 2020/11/02 00:00:00+00 14841.0 12990.0 11490.0 10370.0 340.0 262.0 3011.0
27 8276 Maluku Utara 2020/11/02 00:00:00+00 2232.0 -12598.0 1946.0 -9387.0 75.0 -263.0 211.0
28 8277 Maluku 2020/11/02 00:00:00+00 3863.0 1664.0 3266.0 1338.0 47.0 -28.0 550.0
29 8278 Papua Barat 2020/11/02 00:00:00+00 4189.0 326.0 3655.0 423.0 66.0 19.0 468.0
30 8279 Papua 2020/11/02 00:00:00+00 9037.0 4848.0 4637.0 982.0 129.0 63.0 4271.0
31 8280 Sulawesi Barat 2020/11/02 00:00:00+00 1036.0 -8001.0 841.0 -3796.0 14.0 -115.0 181.0
32 8281 Nusa Tenggara Timur 2020/11/02 00:00:00+00 694.0 -342.0 500.0 -340.0 7.0 -7.0 187.0
33 8282 Gorontalo 2020/11/02 00:00:00+00 3021.0 2331.0 2859.0 2360.0 85.0 78.0 77.0
In [25]:
Out[25]:
415001.0
In [26]:
Out[26]:
345206.0
In [27]:
Out[27]:
14039.0
In [ ]:

Top10 Confimed Case (Part of Data Wrangling)

In [28]:
Out[28]:
index state date Total_Terkonfirmasi Terkonfirmasi_Harian Total_Sembuh Sembuh_Harian Total_MeninggalDunia MeninggalDunia_Harian Total_Aktif
6 8255 DKI Jakarta 2020/11/02 00:00:00+00 107229.0 103378.0 95783.0 92623.0 2288.0 2195.0 9158.0
10 8259 Jawa Timur 2020/11/02 00:00:00+00 53002.0 18632.0 47001.0 18575.0 3799.0 2043.0 2202.0
8 8257 Jawa Barat 2020/11/02 00:00:00+00 36924.0 35694.0 26671.0 26052.0 732.0 709.0 9521.0
9 8258 Jawa Tengah 2020/11/02 00:00:00+00 34618.0 -1965.0 28788.0 2506.0 1766.0 1045.0 4064.0
23 8272 Sulawesi Selatan 2020/11/02 00:00:00+00 18372.0 13302.0 16617.0 12670.0 468.0 386.0 1287.0
19 8268 Sumatera Barat 2020/11/02 00:00:00+00 14940.0 7037.0 10764.0 4379.0 270.0 -153.0 3906.0
26 8275 Riau 2020/11/02 00:00:00+00 14841.0 12990.0 11490.0 10370.0 340.0 262.0 3011.0
12 8261 Kalimantan Timur 2020/11/02 00:00:00+00 14345.0 12668.0 11500.0 10162.0 489.0 468.0 2356.0
21 8270 Sumatera Utara 2020/11/02 00:00:00+00 13277.0 7849.0 10846.0 6280.0 542.0 338.0 1889.0
14 8263 Kalimantan Selatan 2020/11/02 00:00:00+00 11893.0 7549.0 10873.0 6993.0 487.0 336.0 533.0
In [29]:
Out[29]:
index state date Total_Terkonfirmasi Terkonfirmasi_Harian Total_Sembuh Sembuh_Harian Total_MeninggalDunia MeninggalDunia_Harian Total_Aktif
6 8255 DKI Jakarta 2020/11/02 00:00:00+00 107229.0 103378.0 95783.0 92623.0 2288.0 2195.0 9158.0
10 8259 Jawa Timur 2020/11/02 00:00:00+00 53002.0 18632.0 47001.0 18575.0 3799.0 2043.0 2202.0
9 8258 Jawa Tengah 2020/11/02 00:00:00+00 34618.0 -1965.0 28788.0 2506.0 1766.0 1045.0 4064.0
8 8257 Jawa Barat 2020/11/02 00:00:00+00 36924.0 35694.0 26671.0 26052.0 732.0 709.0 9521.0
23 8272 Sulawesi Selatan 2020/11/02 00:00:00+00 18372.0 13302.0 16617.0 12670.0 468.0 386.0 1287.0
12 8261 Kalimantan Timur 2020/11/02 00:00:00+00 14345.0 12668.0 11500.0 10162.0 489.0 468.0 2356.0
26 8275 Riau 2020/11/02 00:00:00+00 14841.0 12990.0 11490.0 10370.0 340.0 262.0 3011.0
14 8263 Kalimantan Selatan 2020/11/02 00:00:00+00 11893.0 7549.0 10873.0 6993.0 487.0 336.0 533.0
21 8270 Sumatera Utara 2020/11/02 00:00:00+00 13277.0 7849.0 10846.0 6280.0 542.0 338.0 1889.0
1 8250 Bali 2020/11/02 00:00:00+00 11846.0 4420.0 10766.0 5729.0 391.0 121.0 689.0
In [30]:
Out[30]:
index state date Total_Terkonfirmasi Terkonfirmasi_Harian Total_Sembuh Sembuh_Harian Total_MeninggalDunia MeninggalDunia_Harian Total_Aktif
10 8259 Jawa Timur 2020/11/02 00:00:00+00 53002.0 18632.0 47001.0 18575.0 3799.0 2043.0 2202.0
6 8255 DKI Jakarta 2020/11/02 00:00:00+00 107229.0 103378.0 95783.0 92623.0 2288.0 2195.0 9158.0
9 8258 Jawa Tengah 2020/11/02 00:00:00+00 34618.0 -1965.0 28788.0 2506.0 1766.0 1045.0 4064.0
8 8257 Jawa Barat 2020/11/02 00:00:00+00 36924.0 35694.0 26671.0 26052.0 732.0 709.0 9521.0
21 8270 Sumatera Utara 2020/11/02 00:00:00+00 13277.0 7849.0 10846.0 6280.0 542.0 338.0 1889.0
12 8261 Kalimantan Timur 2020/11/02 00:00:00+00 14345.0 12668.0 11500.0 10162.0 489.0 468.0 2356.0
14 8263 Kalimantan Selatan 2020/11/02 00:00:00+00 11893.0 7549.0 10873.0 6993.0 487.0 336.0 533.0
23 8272 Sulawesi Selatan 2020/11/02 00:00:00+00 18372.0 13302.0 16617.0 12670.0 468.0 386.0 1287.0
18 8267 Sumatera Selatan 2020/11/02 00:00:00+00 7921.0 3925.0 6394.0 3131.0 428.0 207.0 1099.0
1 8250 Bali 2020/11/02 00:00:00+00 11846.0 4420.0 10766.0 5729.0 391.0 121.0 689.0

Visualization Using Bar Chart

In [32]:
In [ ]:

Visualization Using Pie Chart

In [33]:

Visualization Using Bubble Chart

In [34]:

Visualization Using Tree Maps

In [35]:
In [ ]:

Visualization Using Line Chart

In [36]:
In [37]:
 

/srv/conda/envs/notebook/lib/python3.7/site-packages/plotly/graph_objs/_deprecations.py:385: DeprecationWarning:

plotly.graph_objs.Line is deprecated.
Please replace it with one of the following more specific types
  - plotly.graph_objs.scatter.Line
  - plotly.graph_objs.layout.shape.Line
  - etc.

Dashboard

In [38]:
In [39]:
In [40]:
fig.add_trace(
 go.Scattergeo(
 geojson='https://raw.githubusercontent.com/superpikar/indonesia-geojson/master/indonesia.geojson', 
 featureidkey='properties.state',
 locations=full_latest['state'],
 hovertext = full_latest['text'],
 showlegend=False,
 marker = dict(
 size = 10,
 opacity = 0.8,
 reversescale = True,
 autocolorscale = True,
 symbol = 'square',
 line = dict(
 width=1,
 
 ),
 color=full_latest['Total_Terkonfirmasi'], 
 colorbar_title="Terkonfirmasi", 
 colorbar_x = -0.05,
 )),
 
 row=1, col=1
)
fig.update_layout(
    geo_scope='asia',
    height=600)
fig.update_geos(fitbounds="locations")
In [41]:
fig.add_trace(
 go.Indicator(
 mode='number',
 value=Total_Terkonfirmasi_fix,
 title='Total terkonfirmasi',
 ),
 row=1, col=4
)
fig.add_trace(
 go.Indicator(
 mode='number',
 value=Total_Sembuh_fix,
 title='Total sembuh',
 ),
 row=1, col=5
)
fig.add_trace(
 go.Indicator(
 mode='number',
 value=Total_MeninggalDunia_fix,
 title='Total meninggal',
 ),
 row=1, col=6
)
In [42]:
fig.add_trace(
 go.Bar(
 x=Top10kasus_terkonfirmasi['state'],
 y=Top10kasus_terkonfirmasi['Total_Terkonfirmasi'], 
 name= 'Terkonfirmasi',
 marker=dict(color='Yellow'), 
 showlegend=True,
 ),
 row=2, col=4
)
fig.add_trace(
 go.Bar(
 x=Top10kasus_sembuh['state'],
 y=Top10kasus_sembuh['Total_Sembuh'], 
 name= 'Sembuh',
 marker=dict(color='Blue'), 
 showlegend=True),
 row=3, col=4
)
fig.add_trace(
 go.Bar(
 x=Top10kasus_meninggaldunia['state'],
 y=Top10kasus_meninggaldunia['Total_MeninggalDunia'], 
 name= 'Meninggal',
 marker=dict(color='Green'), 
 showlegend=True),
 row=4, col=4
)
In [ ]: